Live freelance tracking. Raw descriptions turned into structured data. Find your next tech project without the noise.
upwork.com ๐ข 2026-05-28
๐น Sage 50 Handwerk SQL Data Mapping & Extraction
๐ค Client: ๐ฆ๐น Austria Member since 2016-12-03
๐ฐ Price: ****
๐ฉ Problem: Lack of schema visibility and safe access methods for extracting historical customer and project data from a Sage 50 Handwerk MS SQL backend.
๐ฆ Existing: Sage 50 Handwerk installation, MS SQL Server backend (~50 GB, 10 years historical data).
Specifications:
[Target] Sage 50 Handwerk (Plus/Professional/Quantum)
[Method] Read-only SQL access / Sandbox backup restoration
[Stack] MS SQL Server, PostgreSQL (external tagging store)
[Format] Table maps: Customers, Projects (Auftrรคge), Line items (Leistungspositionen), Invoices, Contact data
[Security] Read-only permissions, DSGVO compliance
[Target] Free-text trade description identification (e.g., flat roof, conservatory)
Workflow:
1. Establishment of read-only SQL access or sandbox environment.
2. Schema mapping of core customer and project tables.
3. Analysis of free-text storage for trade-specific keyword extraction.
4. Identification of version-specific quirks and locking behaviors.
5. Architectural review of SQL-to-Postgres synchronization pipeline.